SELECT	Name,
		(SELECT COUNT(Album.Title)
		FROM ArtistAlbumLink INNER JOIN Album ON ArtistAlbumLink.AlbumID = Album.AlbumID
		WHERE
			ArtistAlbumLink.ArtistPersonID = ArtistPerson.ArtistPersonID
		GROUP BY
			ArtistAlbumLink.ArtistPersonID
		) AS AantalAlbums,
		(SELECT COUNT(Album.Title)
		FROM ArtistAlbumLink INNER JOIN Album ON ArtistAlbumLink.AlbumID = Album.AlbumID
		WHERE
			ArtistAlbumLink.ArtistPersonID = ArtistPerson.ArtistPersonID AND Album.StatusID = 1
		GROUP BY
			ArtistAlbumLink.ArtistPersonID
		) AS EigenAlbums
FROM
	ArtistPerson			
WHERE
	Name <> '(%'